package com.mapper;

import com.pojo.Siteids;
import com.pojo.Sitepoint;
import com.pojo.Siteproject;
import com.pojo.Siteroute;

import java.util.List;

public interface SiteidsMapping {
    int deleteByPrimaryKey(Integer id);

    int insert(Siteids record);

    int insertSelective(Siteids record);

    Siteids selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(Siteids record);

    int updateByPrimaryKey(Siteids record);





    //根据计划表的路线外键查询巡检点的id
    public List<Integer> selectpointidbyrouteid(Integer id);


    public List<Siteids> selecrsiteids();


    //根据id查询计划
    public Siteproject selectprojectbyid(Integer id);
    //根据id查询点
    public Sitepoint selectpointbyid(Integer id);
    //根据id查询路线
    public Siteroute selectroutebyid(Integer id);


    //删除计划时会删除相关的明细
    public List<Integer> selectminxiidbyid(Integer id);


    //根据任务id查询计划外键id
    public Integer selectprojectidbyquestid(Integer id);




    //假如在添加完计划后再在路线中加入巡检带点，应该在展示明细时先删除一遍再添加一遍
    //获取明细的所有id 并删除所有的明细
    public List<Integer> selectmingxiids();

    //获取所有的计划id
    public List<Integer> selectprojectids();

    //根据计划id查询计划
    public Siteproject selectprojectbyidthree(Integer id);




}